import pandas as pd
import xlwings as xw    
import os

app = xw.App(visible=True)

for fname in os.listdir('.'):
    if fname.endswith('.xlsx'):
        wb = app.books.open(fname)
        sheet = wb.sheets['sheet页名称']
        # df = pd.DataFrame(sheet.range('A1').expand().value)
        df = sheet.range('A1').options(pd.DataFrame,expand='table', index=False, header=False).value
        
        # df['列名'] = df['列名'].apply(lambda x: x.split(';'))
        split_columns = df['列名'].str.split('分隔符', expand=True)
        df['长'] = split_columns[0]
        df['宽'] = split_columns[1]
        df['高'] = split_columns[2]
        
        # 删除原有列
        df.drop('列名')
        sheet.range('A1').value = df
        wb.save()
app.quit()